HTML_InsideTag_ByIndex

Checks if LocIndex is found between open and close of HTMLTag or between close ...

VBInstr_Numeric

Finds location of 1st numeric character inside string starting from a certain ...

SwitchTextinCells

Switch text inside cells with another text. This was needed to correct an bug ...

gsplit usage

How to use gsplit to split large files into smaller parts to allow to read it. ...

GSplitPDF.zip

ReplaceStrings

Replace strings found in list of strings from inside a string, does taht make ...

Fix Excel Issue

Fixing Excel broken spreadsheet issue. When working with some large ...

ReadBinaryBuffer

Reads file in binary mode as blocks Starts reading from start in sequential ...

ReadBinaryChunk

Reads certain chunk of a file in binary. Used with large files (like ~7gb ...

ReadLastChars

Reads last some characters of a file, needs to see contents of large files that ...

Dropdown button commands

A drop-down of multiple commands in pure VBA. Needed this in a large Excel-VBA ...

DropdownButton.zip

ANmAdvancedFilter

Filter table inside Excel the fast way (using advanced filter) into another ...

ANmaSQL_UpdateDateStatement

Creates "Update Table " SQL statements to be executed inside SQL to modify ...